﻿--Insert relation types
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(1,'!','Antonym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(2,'@','Hypernym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(3,'@i','Instance hypernim');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(4,'~','Hyponym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(5,'~i','Instance hyponym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(6,'#m','Member holonym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(7,'#s','Substance holonym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(8,'#p','Part holonym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(9,'%m','Member meronym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(10,'%s','Substance meronym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(11,'%p','Part meronym');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(12,'=','Attribute');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(13,'+','Derivationally related form');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(14,';c','Domain of synset - TOPIC');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(15,'-c','Member of this domain - TOPIC');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(16,';r','Domain of synset - REGION');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(17,'-r','Member of this domain - REGION');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(18,';u','Domain of synset - USAGE');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(19,'-u','Member of this domain - USAGE');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(20,'*','Entailment');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(21,'>','Cause');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(22,'^','Also see');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(23,'$','Verb group');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(24,'&','Similar to');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(25,'<','Participle of verb');
INSERT INTO [RelationTypes] ([RelationTypeId],[Symbol],[Name]) VALUES(26,'\','Pertainym');
--update the reflect field
UPDATE [RelationTypes] SET [Reflect]=1 WHERE [RelationTypeId]=1; 
UPDATE [RelationTypes] SET [Reflect]=4 WHERE [RelationTypeId]=2;
UPDATE [RelationTypes] SET [Reflect]=5 WHERE [RelationTypeId]=3;
UPDATE [RelationTypes] SET [Reflect]=2 WHERE [RelationTypeId]=4;
UPDATE [RelationTypes] SET [Reflect]=3 WHERE [RelationTypeId]=5;
UPDATE [RelationTypes] SET [Reflect]=9 WHERE [RelationTypeId]=6;
UPDATE [RelationTypes] SET [Reflect]=10 WHERE [RelationTypeId]=7;
UPDATE [RelationTypes] SET [Reflect]=11 WHERE [RelationTypeId]=8;
UPDATE [RelationTypes] SET [Reflect]=6 WHERE [RelationTypeId]=9;
UPDATE [RelationTypes] SET [Reflect]=7 WHERE [RelationTypeId]=10;
UPDATE [RelationTypes] SET [Reflect]=8 WHERE [RelationTypeId]=11;
UPDATE [RelationTypes] SET [Reflect]=12 WHERE [RelationTypeId]=12
UPDATE [RelationTypes] SET [Reflect]=13 WHERE [RelationTypeId]=13;
UPDATE [RelationTypes] SET [Reflect]=15 WHERE [RelationTypeId]=14;
UPDATE [RelationTypes] SET [Reflect]=14 WHERE [RelationTypeId]=15;
UPDATE [RelationTypes] SET [Reflect]=17 WHERE [RelationTypeId]=16;
UPDATE [RelationTypes] SET [Reflect]=16 WHERE [RelationTypeId]=17;
UPDATE [RelationTypes] SET [Reflect]=19 WHERE [RelationTypeId]=18;
UPDATE [RelationTypes] SET [Reflect]=18 WHERE [RelationTypeId]=19;
UPDATE [RelationTypes] SET [Reflect]=23 WHERE [RelationTypeId]=23;
UPDATE [RelationTypes] SET [Reflect]=24 WHERE [RelationTypeId]=24;
--insert parts of speech
INSERT INTO [PartsOfSpeech] ([PosId],[Abreviation],[Name]) VALUES(1,'n','noun');
INSERT INTO [PartsOfSpeech] ([PosId],[Abreviation],[Name]) VALUES(2,'v','verb');
INSERT INTO [PartsOfSpeech] ([PosId],[Abreviation],[Name]) VALUES(3,'a','adjective');
INSERT INTO [PartsOfSpeech] ([PosId],[Abreviation],[Name]) VALUES(4,'r','adverb');
INSERT INTO [PartsOfSpeech] ([PosId],[Abreviation],[Name]) VALUES(5,'s','adjective satellite');